Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_DIMENSIONS

`ALL_OLAP2_DIMENSIONS` lists all the OLAP dimensions in the Oracle instance.

OLAP dimensions created with the `CWM2` APIs have no association with database dimension objects. OLAP dimensions created in Enterprise Manager are based on database dimension objects.

Column | Data Type | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the dimension.
`DIMENSION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the dimension.
`PLURAL_NAME` | `VARCHAR2(30)` |  | Plural name for the dimension. Used for display.
`DISPLAY_NAME` | `VARCHAR2(30)` |  | Display name for the dimension.
`DESCRIPTION` | `VARCHAR2(2000)` |  | Description of the dimension.
`DEFAULT_DISPLAY_HIERARCHY` | `VARCHAR2(30)` | `NOT NULL` | Default display hierarchy for the dimension.
`INVALID` | `VARCHAR2(1)` | `NOT NULL` | Whether or not the dimension is valid. See "Validating and Committing OLAP Catalog Metadata"
`DIMENSION_TYPE` | `VARCHAR2(10)` |  | Not used.